
*Read the excel file for the CPI prices
import excel "$statecpi/Relative_Prices_by_State2_FINAL_forSTATA.xlsx", sheet("forSTATA") firstrow
reshape long all goods servo, i(stateid) j(year)

sort stateid year

* Create the link variable to merge childcosts per state
egen state_year=concat(year stateid)

drop state stateid year 

save "$temp/stateCPI.dta", replace

clear 





